<?php

class Application_Model_DbTable_Product extends Zend_Db_Table_Abstract {
    
    protected $_name = 'Product';
    
    public function getList4Grid(){
        $result = array();
        $sql = "SELECT p.ID,p.Ref,p.Photo,t.TypeProduct as Type,p.`Usage`,p.Style,p.Price,p.PriceLevel,p.UnitWeight FROM Product p left join TypeProduct t on p.ProductTypeID = t.ID";
        $result = $this->getAdapter()->fetchAssoc($sql);        
        return $result;
    }
    
}